Tables
SQLServer
>
iMIS1521GA
> Tables
Name
dbo.AccessArea
dbo.AccessItem
dbo.AccessMain
dbo.AccountingMethodRef
dbo.AccountPending
dbo.AclPermissionTypeRef
dbo.ActionPlan
dbo.Activity
dbo.Activity_Attach
dbo.Activity_tmpID
dbo.ActivityImporter
dbo.AddressCategoryPreferences
dbo.AddressCategoryRef
dbo.AddressFormatRef
dbo.AddressMain
dbo.AddressPurposeContactType
dbo.AddressPurposeRef
dbo.AddressStatusRef
dbo.AddressToUse
dbo.AddressTypeRef
dbo.Admin_Section_Ref
dbo.Admin_Security
dbo.Admin_Security_Log
dbo.Affect_Cert_Register_ie
dbo.Affect_Name_Fin_ie
dbo.Affect_Name_ie
dbo.Appeal
dbo.Appeal_Premiums
dbo.AppealMain
dbo.AppealParticipation
dbo.AppealProduct
dbo.AppealStatusRef
dbo.asiDBFuncChangeLog
dbo.asiDBProcChangeLog
dbo.asiDBSchemaChangeLog
dbo.asiDBViewChangeLog
dbo.AsiNrdsAssociation
dbo.AsiNrdsLog
dbo.AsiNrdsMember
dbo.AsiNrdsMemberDemographic
dbo.AsiNrdsMemberDesignation
dbo.AsiNrdsMemberEducation
dbo.AsiNrdsMemberFinancial
dbo.AsiNrdsMemberSupplemental
dbo.AsiNrdsOffice
dbo.AsiNrdsOfficeSupplemental
dbo.AsiNrdsQueue
dbo.AsyncStatusMonitor
dbo.AtomPanel
dbo.AtomPanelFactoryStateRef
dbo.AtomPanelPurposeRef
dbo.AtomPanelStatusRef
dbo.AtomPanelTemplate
dbo.AtomPanelTemplateTypeRef
dbo.AtomPanelTypeRef
dbo.AtomPanelWebsite
dbo.AVSBillingLog
dbo.Background
dbo.BadAddressReasonRef
dbo.Basket_Dues
dbo.Basket_Function
dbo.Basket_Meeting
dbo.Basket_Order
dbo.Basket_Payment
dbo.Batch
dbo.BatchActionRef
dbo.BatchLineStatusRef
dbo.BatchSetup
dbo.BatchStatusRef
dbo.BillingSetup
dbo.Campaign
dbo.CampaignMain
dbo.CampaignParticipation
dbo.CampaignStatusRef
dbo.CampaignTypeRef
dbo.Cart
dbo.CartBilling
dbo.CartEvent
dbo.CartEventFunction
dbo.CartItem
dbo.CartOrder
dbo.Cash_Accounts
dbo.CCAuthAcct
dbo.Cert_Comp_Cat
dbo.Cert_Prog_Lines
dbo.Cert_Program
dbo.Cert_Register
dbo.CertificationModule
dbo.CertificationModuleGrade
dbo.CertificationModuleProduct
dbo.CertificationModuleRegistration
dbo.CertificationModuleStatusRef
dbo.CertificationProgram
dbo.CertificationProgramCertificationModule
dbo.CertificationProgramProduct
dbo.CertificationProgramRegistration
dbo.CertificationProgramRegistrationCertificationModule
dbo.ChangeLog
dbo.ChangeProperty
dbo.CheckCategoryRef
dbo.CM5Migration
dbo.CM5MigrationVariableMapping
dbo.Cmty_Administrators
dbo.Cmty_Discussion_Forums
dbo.Cmty_Discussion_Posts
dbo.Cmty_Email_Notification
dbo.Cmty_Invitees
dbo.Cmty_News
dbo.Cmty_Read_Tracking
dbo.Cmty_Shared_Files
dbo.Cmty_Shared_Folders
dbo.Cmty_Subscription
dbo.Comment_Log
dbo.Comment_Types
dbo.CommissionRateTypeRef
dbo.Committee_Minutes
dbo.Committee_Position
dbo.Communication
dbo.CommunicationReasonRef
dbo.Community
dbo.CompanyNaicsSic
dbo.ComparisonRef
dbo.Component_Email
dbo.Component_Email_Variable_Ref
dbo.Component_Interest_Category
dbo.Component_Interest_Group
dbo.Component_Ref
dbo.Component_Script_Ref
dbo.ComponentCategoryRef
dbo.ComponentRegistry
dbo.ComponentRegistryCategory
dbo.ContactAddress
dbo.ContactBiography
dbo.ContactCommunicationReasonPreferences
dbo.ContactDuplicateCheckFormula
dbo.ContactDuplicateCheckFormulaTypeRef
dbo.ContactEducation
dbo.ContactFundraising
dbo.ContactLog
dbo.ContactMain
dbo.ContactOffering
dbo.ContactOfferingRef
dbo.ContactPicture
dbo.Contacts
dbo.ContactSalutation
dbo.ContactSkill
dbo.ContactSkillRef
dbo.ContactStatusRef
dbo.ContactTypeRef
dbo.Content
dbo.Content_Authority_Group
dbo.Content_Authority_Producer
dbo.Content_Authority_Ref
dbo.Content_Change_Request
dbo.Content_File
dbo.Content_HTML
dbo.Content_Link
dbo.Content_Pages
dbo.Content_Publish_Server
dbo.Content_Security_Group
dbo.Content_Workflow_Log
dbo.ContentChangeRequest
dbo.ContentManagerAuthorityGroup
dbo.ContentUserDefinedFieldValue
dbo.ContentWorkflowParameters
dbo.CostMethodRef
dbo.CostTier
dbo.Counter
dbo.Country_Addr_Layouts
dbo.Country_Names
dbo.CountryRef
dbo.CreditTypeRef
dbo.CultureRef
dbo.CustomerExperience
dbo.CustomerExperienceStatusChange
dbo.CustomerExperienceStatusRef
dbo.CustomTabFields
dbo.Data_Type_Ref
dbo.DataTypeRef
dbo.Deferral_Matrix
dbo.DeferredConversionWork
dbo.DeferredIncomeWork
dbo.DeploymentPackageRef
dbo.DocumentMain
dbo.DocumentStatusRef
dbo.DocumentStorage
dbo.DocumentTypeRef
dbo.Donation_Premium
dbo.DonationReport
dbo.DuesCycles
dbo.DueToDueFrom
dbo.Duplicate
dbo.Duplicate_Group
dbo.Education
dbo.EducationLevelRef
dbo.Email_Contact
dbo.Error
dbo.EventGuest
dbo.EventRegistrant
dbo.EventRegistrationAnswer
dbo.EventSetupFunctionGroup
dbo.EventSetupGeneral
dbo.EventSetupGroup
dbo.EventSetupGuest
dbo.EventSetupLabel
dbo.EventSetupQuestion
dbo.EventSetupQuestionChoice
dbo.EventSetupRegistrant
dbo.Exchange_Rate
dbo.ExchangeRateHistory
dbo.ExecutionModeRef
dbo.Exhb_Booth
dbo.Exhb_Booth_Hist
dbo.Exhb_Form
dbo.Exhb_Form_Master
dbo.Exhb_Meet
dbo.Exhb_Meet_Contact
dbo.Exhb_Meet_Form
dbo.Exhb_Order_Pymt
dbo.Exhb_Prod
dbo.Exhb_Prod_Con
dbo.Exhb_Prod_Mast
dbo.Exhb_Reg
dbo.Exhb_Script
dbo.Exhb_Setup
dbo.Exhb_Srvc_Comp
dbo.Exhb_Srvc_Contr
dbo.Exhb_Upsell
dbo.Exhb_Wait_List
dbo.ExpenseItem
dbo.ExperienceDefinition
dbo.ExperienceDefinitionStatusRef
dbo.Expo_Reg_Class
dbo.ExpoCad_Prod
dbo.ExportType
dbo.FieldDesign
dbo.FieldDesignSectionLookup
dbo.FieldSection
dbo.File_Type_Ref
dbo.FileTypeRef
dbo.FinancialEntityDueTo
dbo.FinancialEntityGLAccount
dbo.FirstPaymentDateTypeRef
dbo.Freight_Dollar
dbo.Freight_Qty
dbo.Freight_Rate
dbo.FullAddress
dbo.Fund
dbo.FundFamilyRef
dbo.FundFundType
dbo.FundraisingPreferenceRef
dbo.FundTypeRef
dbo.GatewayResultRef
dbo.GatewayTransactionRef
dbo.GatewayTypeRef
dbo.Gen_Descriptions
dbo.Gen_Tables
dbo.Generic
dbo.GenericLink
dbo.GiftAidClaimDetail
dbo.GiftAidClaimHeader
dbo.GiftAidDeclaration
dbo.GiftReport
dbo.GLEntryTypeRef
dbo.GLExportSummaryLevelRef
dbo.GLSourceItemTypeRef
dbo.GLTransactionMain
dbo.GradeRef
dbo.GroupInstanceRole
dbo.GroupMain
dbo.GroupMember
dbo.GroupMemberDetail
dbo.GroupMemberOptions
dbo.GroupMemberStatusRef
dbo.GroupOpportunityType
dbo.GroupPerspective
dbo.GroupRoleRef
dbo.GroupStatusRef
dbo.GroupTypeMemberStatus
dbo.GroupTypeRef
dbo.GroupTypeRole
dbo.HandlingPriceRef
dbo.HIControlTypeRef
dbo.Hierarchy
dbo.HierarchyRoot
dbo.History
dbo.Hotel_Log
dbo.IMISTable
dbo.ImportFileTypeRef
dbo.Individual
dbo.Informz_Mailings
dbo.Informz_Surveys
dbo.Input_Type_Ref
dbo.Institute
dbo.Int_Code
dbo.Interest_Category
dbo.IntervalTypeRef
dbo.InventoryTransactionLogCost
dbo.InventoryTransactionLogLine
dbo.InventoryTransactionLogMain
dbo.Invoice
dbo.Invoice_Lines
dbo.InvoiceTypeRef
dbo.IQA_Query_Cache
dbo.Iso_Currency_Codes
dbo.Job_Record
dbo.JournalEntryTypeRef
dbo.LegacySecurityLevelRef
dbo.Legis_Bills
dbo.License
dbo.LicenseLegacyList
dbo.LicenseLegacyMap
dbo.LicenseMain
dbo.LicenseMap
dbo.LicenseMapMaster
dbo.LicenseMaster
dbo.LicenseOrganization
dbo.LicenseTypeRef
dbo.LicenseUser
dbo.LinePricingRef
dbo.ListItem
dbo.ListMain
dbo.LocaleRef
dbo.Location
dbo.LocationStatusRef
dbo.Log_Field
dbo.Log_Main
dbo.Mail_Lists
dbo.Mail_Subscribers
dbo.MailCodeRef
dbo.Match_Interest
dbo.MatchingGift
dbo.MatchingGiftPlan
dbo.MatchingGiftPlanFundType
dbo.MatchingGiftPlanRelationship
dbo.MatchingGiftPlanRule
dbo.MatchingGiftPlanTypeRef
dbo.MatchingModeRef
dbo.MatchingPeriodRef
dbo.Meet_Hotel
dbo.Meet_Master
dbo.Meet_Reg_Class
dbo.Meet_Resources
dbo.Meet_Std_Resrc
dbo.Mem_Trib_Code
dbo.Member_Types
dbo.MemorialTribute
dbo.MemorialTributeCodeRef
dbo.MemorialTributeNotificationMember
dbo.MethodSetTypeRef
dbo.Microsite
dbo.Name
dbo.Name_Address
dbo.Name_AlternateId
dbo.Name_Annuity
dbo.Name_CEU
dbo.Name_Demo
dbo.Name_Estates
dbo.Name_Fin
dbo.Name_FR
dbo.Name_FRAdditionalInfo
dbo.Name_FREventInformation
dbo.Name_FRProfile
dbo.Name_FRSurveyQuestion
dbo.Name_FRTeamInformation
dbo.Name_FRTransactionLog
dbo.Name_Indexes
dbo.Name_JoinOnline
dbo.Name_Log
dbo.Name_Lookup
dbo.Name_MatchPlan
dbo.Name_Note
dbo.Name_Notify
dbo.Name_Picture
dbo.Name_PL_Pref
dbo.Name_PlannedGiving
dbo.Name_Research
dbo.Name_Salutation
dbo.Name_Security
dbo.Name_Security_Groups
dbo.Name_Staff
dbo.Name_TabTest
dbo.Name_Volunteer
dbo.Nav_Menu
dbo.Nav_Menu_Feature
dbo.Nav_Menu_Security_Group
dbo.Nav_Menu_Setup_Log
dbo.Nav_Menu_Website
dbo.Nav_Menu_Workflow_Log
dbo.NavigationExport
dbo.NavigationLegacySecurityRolesExport
dbo.NavigationMain
dbo.NavigationPaneRef
dbo.NavigationSecurityGroupsExport
dbo.NavigationSecurityRolesExport
dbo.NavigationWorkflowParameters
dbo.Note
dbo.NotePurposeRef
dbo.ObjectMetaData
dbo.OfferedCustomerExperience
dbo.Offering
dbo.OfferingStatusRef
dbo.OpportunityClassRef
dbo.OpportunityCompetitor
dbo.OpportunityDefaultStatusRef
dbo.OpportunityHistory
dbo.OpportunityMain
dbo.OpportunityMainDonor
dbo.OpportunityMainMember
dbo.OpportunityMainSales
dbo.OpportunityStatusRef
dbo.OpportunityType
dbo.Order_Badge
dbo.Order_Lines
dbo.Order_Meet
dbo.Order_Payments
dbo.Order_Type
dbo.OrderAnswer
dbo.OrderCategory
dbo.OrderCategoryParentLookup
dbo.OrderCheckout
dbo.OrderFulfillmentStatusRef
dbo.OrderPickLine
dbo.OrderProduct
dbo.OrderProductCategoryLookup
dbo.OrderProductCrossSellLookup
dbo.Orders
dbo.Orders_VAT
dbo.OrderStateRef
dbo.OrderSuperProductAttribute
dbo.OrderSuperProductAttributeLookup
dbo.OrderSuperProductAttributeValue
dbo.OrderSuperProductChildProduct
dbo.OrderSuperProductChildProductAttribute
dbo.Org_Control
dbo.Org_Interest
dbo.Organization_Demo
dbo.OrganizationMain
dbo.OutboundCommunicationStatusRef
dbo.PackageItem
dbo.PackageLogStatusRef
dbo.PackageLogSupplement
dbo.PackageMain
dbo.PackageQueue
dbo.PackageQueueReleaseTypeRef
dbo.PackageStatusRef
dbo.PanelDefinition
dbo.PaperSizeRef
dbo.PaymentApplicationRestrictionRef
dbo.PaymentDetailStatusRef
dbo.PaymentMain
dbo.PaymentTermsCustomLine
dbo.PciAuditLog
dbo.Perspective
dbo.PhysicalAddress
dbo.Picture
dbo.PicturePurposeRef
dbo.Pipeline
dbo.PipelineStage
dbo.PledgeReport
dbo.PostalCodeRef
dbo.PotentialMatchingGift
dbo.PrefixRef
dbo.PriceBasisRef
dbo.PricingTypeRef
dbo.ProcessEngineType
dbo.Prod_Label_Pref
dbo.Producer
dbo.Product
dbo.Product_Cat
dbo.Product_Cert
dbo.Product_FR
dbo.Product_Function
dbo.Product_Instance
dbo.Product_Inventory
dbo.Product_Kit
dbo.Product_Location
dbo.Product_Lot
dbo.Product_Price
dbo.Product_Pub
dbo.Product_Sub
dbo.Product_Substitute
dbo.Product_Tax
dbo.Product_Trans
dbo.Product_Type
dbo.ProductStatusRef
dbo.Program
dbo.ProgramGroup
dbo.ProgramGroupStatusRef
dbo.ProgramStatusRef
dbo.PromotionRuleRef
dbo.PropertyDefinition
dbo.Prospect
dbo.Publish_Message_Log
dbo.Publish_Priority_Ref
dbo.Publish_Request
dbo.Publish_Request_Detail
dbo.Publish_Request_Status_Ref
dbo.Publish_Server_Ref
dbo.PublishMessageLog
dbo.PublishPriorityRef
dbo.PublishRequest
dbo.PublishRequestDetail
dbo.PublishRequestStatusRef
dbo.PublishServerRef
dbo.Purge_Ctrl_ie
dbo.QualityRef
dbo.QueryResultItem
dbo.QueryResultMain
dbo.Receipt
dbo.ReceiptLine
dbo.ReceiptMain
dbo.ReceiptTypeRef
dbo.RecurringDonationCommitment
dbo.RecurringDonationExpectedPayment
dbo.RecurringDonationExpectedPaymentSet
dbo.RecurringDonationExpectedPaymentSetStatusRef
dbo.RecurringDonationExpectedPaymentStatusRef
dbo.RecurringDonationFrequencyRef
dbo.RecurringDonationMatchStatusRef
dbo.Ref_Client
dbo.Ref_Provider
dbo.Ref_Table_Ref
dbo.Referral
dbo.RegistrationStatusChange
dbo.RegistrationStatusRef
dbo.Relationship
dbo.Relationship_Types
dbo.RelationshipCategoryRef
dbo.RelationshipMain
dbo.RelationshipTypeCategory
dbo.RelationshipTypeRef
dbo.Report_Desc
dbo.Request_Status_Ref
dbo.ResponseMediaRef
dbo.ResponseTypeRef
dbo.RestockPriceRef
dbo.RFMDefinition
dbo.RFMDefinition_Detail
dbo.RFMMain
dbo.RoleMain
dbo.RoundingMultipleRef
dbo.Rpt_3rdPartyPayerInfo
dbo.Rpt_BadgeTbl
dbo.Rpt_InvoiceTbl
dbo.Rpt_KitTbl
dbo.Rpt_ProductInventory
dbo.Rpt_TicketTbl
dbo.Rpt_WorkingTbl
dbo.RuleCriterion
dbo.RuleFilter
dbo.RuleMain
dbo.RuleSourceDesign
dbo.RuleSourcePublish
dbo.SalesHistory
dbo.SalesHistoryMemorialTribute
dbo.SalesHistoryRelationshipTypeRef
dbo.SalesHistorySoftCredit
dbo.SalesLocationStatusRef
dbo.SalutationRef
dbo.ScheduledTask
dbo.ScheduledTaskHistory
dbo.ScheduledTaskService
dbo.ScreenResolutionRef
dbo.Search_Collection
dbo.Search_Requests
dbo.SeasonalFullAddress
dbo.Security_Filters
dbo.Security_Group_Rule
dbo.Security_Group_Sync
dbo.Security_Groups
dbo.Security_Modes
dbo.Security_Tables
dbo.SegmentationJob
dbo.SegmentationJobStatusRef
dbo.SegmentDefinition
dbo.Sender_Codes
dbo.SequenceCounter
dbo.Service_Request
dbo.ServiceStatusRef
dbo.ShipPriceRef
dbo.SoftCreditRelationshipType
dbo.SolicitationMain
dbo.SolicitationSource
dbo.SolicitationStatusRef
dbo.SortNameAdjustment
dbo.SortNameAdjustmentActionRef
dbo.Source_Codes
dbo.SourceCode
dbo.SourceCodeStatusRef
dbo.SourceCodeTypeRef
dbo.StandardPageRef
dbo.State_Codes
dbo.StateProvinceRef
dbo.Stored_List
dbo.Style_Options
dbo.Sub_Component_Ref
dbo.Subscriptions
dbo.SuffixRef
dbo.SupplementMain
dbo.SupplementStatusRef
dbo.SupplementTypeRef
dbo.Survey
dbo.System_Params
dbo.System_Variable
dbo.SystemConfig
dbo.SystemConfigPageParameterRef
dbo.SystemConfigPageRef
dbo.SystemConfigParameterRef
dbo.SystemConfigXml
dbo.SystemEntity
dbo.SystemRef
dbo.Tag
dbo.Tagged_Page_Color_Ref
dbo.Tagged_Page_Component_Column
dbo.Tagged_Page_Format_Ref
dbo.Tagged_Page_Format_Type_Ref
dbo.Tagged_Page_Interest_Category
dbo.Tagged_Page_Layout
dbo.Tagged_Page_Portlet
dbo.Tagged_Page_PortletIC
dbo.Tagged_Page_Section
dbo.Tagged_Page_Title_Ref
dbo.Tagged_Portlet
dbo.Tagged_Section
dbo.Tagged_Section_Template
dbo.Tagged_Template
dbo.Tagged_Template_Field
dbo.TagRelatedName
dbo.TagRelationship
dbo.TagRelationshipTypeRef
dbo.TaskItem
dbo.TaskItemStatusRef
dbo.TaskMain
dbo.TaskNotifyCreatorRef
dbo.TaskPriorityRef
dbo.TaskStatusRef
dbo.TaskTypeRef
dbo.TaxAuthorityCategory
dbo.TaxAuthorityFinancialEntity
dbo.TaxAuthorityLevelRef
dbo.TaxScheduleAuthority
dbo.tempFormula
dbo.tempTypeNamesList
dbo.Terms
dbo.TimeZoneRef
dbo.Trans
dbo.Trans_Notify
dbo.Trans_SoftCredit
dbo.TransactionTypeRef
dbo.TransWatch
dbo.UD_Field
dbo.UD_Table
dbo.UD_WindowFields
dbo.UD_WindowHeader
dbo.UniformDistribution
dbo.UniformLicense
dbo.UniformLink
dbo.UniformRegistry
dbo.UniformTag
dbo.UniformTypeRef
dbo.UnofferedCustomerExperience
dbo.URL_Mapping
dbo.URLMapping
dbo.URLs
dbo.UsedSourceCode
dbo.User_Defined_Content_Labels
dbo.User_Defined_Field
dbo.User_Tab_Pref
dbo.User_Tab_Pref_Detail
dbo.UserDefinedCustomerExperience
dbo.UserDefinedFieldRef
dbo.UserDefinedMultiInstanceProperty
dbo.UserDefinedSingleInstanceProperty
dbo.UserLegacyInfo
dbo.UserMain
dbo.UserProcess
dbo.UserRole
dbo.Users
dbo.UserToken
dbo.Variable_Type_Ref
dbo.Vat_Rule
dbo.Vat_Rule_Set
dbo.VAT_Trans
dbo.VerticalAlignmentRef
dbo.W_Reports
dbo.WarehouseCarrier
dbo.WarehouseStatusRef
dbo.WarehouseTypeRef
dbo.Web_Counter
dbo.Website
dbo.Website_Content_Authority
dbo.Website_Security_Group
dbo.WebUserControlRef
dbo.Workflow_Status_Ref
dbo.WorkflowDemo
dbo.WorkflowDemoLog
dbo.WorkflowInstance
dbo.WorkflowQueue
dbo.WorkflowQueueStatusRef
dbo.WorkflowService
dbo.WorkflowServiceWorker
dbo.WorkflowStatusRef
dbo.WorkInvoiceMain
dbo.WorkItem
dbo.WorkItemQueue
dbo.WorkOrderMain
dbo.Zip_Code
dbo.Zip3
dbo.Zone_Code